///Project: Introducing GLP Paper Table 7
///Stata14 

**************** Table 7**************************
clear all
use "MP Salaries.dta"
gen MPsalary=MPSalaryUSAnnual
keep if MPsalary<.
replace MPsalary=round(MPsalary)
sort MPsalary
sum MPsalary
sum MPsalary if wealth==1
sum MPsalary if wealth==0
sum MPsalary if regime==0
sum MPsalary if regime==1
sum MPsalary if region==1
sum MPsalary if region==2
sum MPsalary if region==3
sum MPsalary if region==4
sum MPsalary if region==5
////Row2 
gen salarygdp1=MPsalary/GDPpercapitaCurrentUS
sum salarygdp1
sum salarygdp1 if wealth==1
sum salarygdp1 if wealth==0
sum salarygdp1 if regime==0
sum salarygdp1 if regime==1
by region, sort: sum  salarygdp1


